package controllers;

public class Queries {

	public final static String FIND_EVENT_BY_INITIALLETTER_DATE_CATEGORY_ORDER_BY_NAME = "name like ? and startDate > ? and category = ? and isActive = true order by startDate asc";
	public final static String FIND_EVENT_BY_INITIALLETTER_DATE_ORDER_BY_NAME = "name like ? and startDate > ? and isActive = true order by startDate asc";
	public final static String FIND_EVENT_BY_DATE_CATEGORY_ORDER_BY_NAME = "startDate > ? and category = ? and isActive = true order by startDate asc";
	public final static String FIND_EVENT_BY_DATE_ORDER_BY_NAME = "startDate > ? and isActive = true order by startDate asc";
	public final static String FIND_EVENT_BY_DATE_ORDER_BY_NAME_GROUP_BY_NAME = "select name from Event where startDate > ? and isActive = true group by name order by name asc";
	public final static String FIND_EVENT_BY_NAME_AND_DATE_ORDER_BY_NAME = "name = ? and startDate > ? and isActive = true order by name asc";
	public final static String FIND_EVENT_BY_DATE_AND_NOT_ACTIVE_ORDER_BY_NAME = "startDate > ? and isActive = false order by name asc";
	public final static String FIND_EVENT_BY_INITIALLETTER_DATE_CATEGORY_ORDER_BY_POPULARITY = "name like ? and startDate > ? and category = ? and isActive = true order by clicks desc";
	public final static String FIND_EVENT_BY_INITIALLETTER_DATE_ORDER_BY_POPULARITY = "name like ? and startDate > ? and isActive = true order by clicks desc";
	public final static String FIND_EVENT_BY_DATE_CATEGORY_ORDER_BY_POPULARITY = "startDate > ? and category = ? and isActive = true order by clicks desc"; 
	public final static String FIND_EVENT_BY_DATE_ORDER_BY_POPULARITY = "startDate > ? and isActive = true order by clicks desc";
	
}
